| |
98 Search Results Found |
| 1 |
Forum: Business Intelligence «»
Posted on: Sat, 23 May 2020 03:12 «»
By: oluranti
Re:Invalid Service name in RCU installation for OBIEE 12c
…Hi,
I want to install OBIEE 12c and practice with it on my laptop. I have successfully installed the following:
Oracle Database 12c (I have done the data configuration installation)
Weblogic
BI plaform
but got stuck on RCU step 3 of 8 (picture …
|
| 2 |
Forum: RAC & Failsafe «»
Posted on: Thu, 17 May 2018 10:50 «»
By: sarahLian
Root.sh failed: ORA-39510: CRS error performing start on instance '+ASM1' on '+ASM'
…Hello,
I have some issues with the installation of Oracle RAC 12.2 on RHEL 7. Could you please help me with this issue ?
Thanks in advance.
The root.sh failed with the following error:
ORA-39510: CRS error performing start on instance '+ASM1' …
|
| 3 |
Forum: Marketplace «»
Posted on: Tue, 20 March 2018 05:45 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
New version (2018.03.20) with the following modifications:
Fix bugs in ALTER/MODIFY command introduced in previous version with the "step/ABORT_STEP" option
GRANTS parameter of USER command now support "+" as delimiter in addition …
|
| 4 |
Forum: Server Administration «»
Posted on: Wed, 06 December 2017 21:08 «»
By: lzfhope
Re: global temporay table does not work!
…Today,i found that init parameter "temp_undo_enabled" is set to true,which is the only changed parameter recently!
Have a try,restored it to "false"!
as a result,global temporary table(on commit preserve) could still hold data …
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 29 November 2017 05:12 «»
By: dba4oracle
Re: trigger impacting performance
…Hi,
Below is DDL of master table and trigger source
temp(staging) table is same as master table but no constraints,index,partition and no trigger attached to it
CREATE TABLE "schema1"."Master1"
( "…
|
| 6 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 27 August 2017 13:00 «»
By: rkrishna
Re: Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g
…are in the verge of making the decision to upgrade to 12c, and this extremely slow performance on Inserts is a major blocker. The expectation is that 12c should be at least as fast as 11g, if not better. I am looking for any suggestion on whether we need …
|
| 7 |
Forum: Weblogic & Application Server «»
Posted on: Mon, 05 December 2016 04:34 «»
By: calacausi
Oracle App. Server 10g. error when accessing file on a remote server
…hi,
i need my Forms application access files stored in a remote server. I checked that \\OASServer and \\RemoteServer computers are in the same domain, and the remote directory \\RemoteServer\temp is shared and has full control rights assigned to '…
|
| 8 |
Forum: Reports & Discoverer «»
Posted on: Sun, 04 December 2016 02:31 «»
By: iam78
discoverer 11g configuration fails
…have installed weblogic 10.3.6 and discoverer 11.1.1.2 and discoverer patchset 11.1.1.7,
in the step of configuration of instance when create managed server wls_disco it take a huge time and last it give me error!!!
i read all forums withe same …
|
| 9 |
Forum: Linux «»
Posted on: Tue, 23 August 2016 02:47 «»
By: trantuananh24hg
Tips for Installation 11gr2 on RHEL6
…ago, I finished installation the 11gr2 on RHEL6, and there are some tips here:
1. Install the requirement pacakges
[root@spsdev ~]#yum install local compat-libstdc++-33*
[root@spsdev ~]#yum install local libaio-devel-0.*
[root@spsdev ~]#yum …
|
| 10 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:14 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DDL command
In the same vein than the previous command, CONTENT, McDP allows you to get the DDL of all or part of a database, with the transformation you want, using the DDL command.
Its syntax is:
McDP [<logon>] { -ddl | --ddl } [<…
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 17 May 2016 09:32 «»
By: mjm22
MEMBER OF condition across DB Link
…Hi,
I have come across a scenario that I am struggling to understand...
I am trying to insert to a table a subset of values selected form another table on a remote database. The selection is controlled via a MEMBER OF condition that limits the …
|
| 12 |
Forum: Windows «»
Posted on: Wed, 06 May 2015 23:16 «»
By: dark_prince
Re: How to Insert / Retrieve data in Marathi / Hindi font
…guys. I drop the database. And now for creating new database I found script, I thought before running it i should show that to you guys.
REM ASSUMPTIONS
rem oracle xe has been installed
rem oracle_home has been set
rem oracle_sid has been set
…
|
| 13 |
Forum: Server Administration «»
Posted on: Thu, 28 August 2014 14:17 «»
By: dstolf
Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c
…is a though one, with many variables, so bear with me.
I have created two databases using Oracle dNFS clone. The backup image is stored on ASM and both clones are stored on NFS and use the same backup image. It's a plain simple single instance …
|
| 14 |
Forum: Performance Tuning «»
Posted on: Thu, 17 October 2013 09:57 «»
By: hesaigo999ca
Re: Help with 12c vs 10.2g
…all for being patient and lots of suggestions...
Here so far is extra info as well as the progress I have made so far.
Info...
Roachcoach:I do know what the jobs are doing, the sql is the same in both cases, hence why I consider this to be simple and…
|
| 15 |
Forum: Server Administration «»
Posted on: Mon, 30 September 2013 00:33 «»
By: ishika_20
ORA-30967: operation directly on the Path Table (during CSSCAN process)
…All,
While doing scanning of character set, error occurred in between.
Kindly assist me to solve the problem.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application …
|
| 16 |
Forum: Performance Tuning «»
Posted on: Thu, 11 April 2013 10:52 «»
By: Michel Cadot
Re: How to find out session consuming high resource in the past?
…Ah! you were talking about the columns... I thought the view... sorry.
They indeed are there only in 11g:
mikb2=MIKB2/ILLUVATAR MICHEL> desc DBA_HIST_ACTIVE_SESS_HISTORY
Name Null? Type…
|
| 17 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Sun, 24 February 2013 07:10 «»
By: BLROracle
create remote file with util_file
…Hello,
i´am a newon pl/sql and i have question about util_file.
My environment:
Database is installed on some server, which i have no access.
I have to export some data from this database.
1.At first, i have to create some csv and xml files.
…
|
| 18 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 16:58 «»
By: segan1415
Re: NOLOGGING in Oracle 11gr2
…is reports for DIRECT PATH insert. My observations:
*REDO size reduced by two orders of magnitude, not surprising
*Essentially everything in the Load Profile is reduced by an order of magnitude or more on a per transaction
*On a per second basis much …
|
| 19 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 15:15 «»
By: segan1415
Re: NOLOGGING in Oracle 11gr2
…have changed sequence cache to 100,000 per your recommendation. This change chops about .4ms from my elapsed time per execution. The first two reports (907-908) were run at the same load volume as all my previous reports, then I decided to run my load …
|
| 20 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 10:00 «»
By: segan1415
Re: NOLOGGING in Oracle 11gr2
…seems from the new AWRRPT, I am now swapping log files every fifteen minutes (since there is only 1 switch, I ran a second awrrpt from 801-803 and there was 2 switches - confirming this)
AWRRPT 801-802 (50M REDO LOG FILES)
Toggle Spoiler
WORKLOAD…
|
| 21 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 02:17 «»
By: Roachcoach
Re: NOLOGGING in Oracle 11gr2
…those who cannot download, contents in the spoiler section to save a wall of text
Toggle Spoiler
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Startup Time Release RAC…
|
| 22 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 10 September 2012 07:16 «»
By: kashifchughtai
Re: selecting clob value over dblink
…cannot do any change on remote database. i read on a blog tht it is possible using the global temp table.
something like given below:
create global temporary table LocalTempTableWithClob
(myid number, myclob clob) ON COMMIT PRESERVE ROWS;
…
|
| 23 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 06 September 2012 10:24 «»
By: Michel Cadot
Re: Remote Pipeline or Remote sys_refcursor
…
No, it's me, I was not clear, I was going back to your initial question and ask if you can't from your application open a connection to the other (remote) database and directly get the result from it instead of getting through a db link.
For your …
|
| 24 |
Forum: Backup & Recovery «»
Posted on: Tue, 31 July 2012 14:37 «»
By: drumboy
Re: Flash Recovery ->SYSTEM.DBF
…Jul 31 19:01:57 2012
Starting ORACLE instance (normal)
Tue Jul 31 19:02:20 2012
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Tue Jul 31 20:38:30 2012
Shutting down instance (immediate)
Shutting down …
|
| 25 |
Forum: Windows «»
Posted on: Wed, 28 March 2012 02:36 «»
By: ranamirfan
Re: Unable to install oracle 11gR2 on Windows 7 Professional.
…file.
[main] [ 2012-03-28 10:23:38.047 AST ] [HAUtils.getHASHome:631] Oracle home from system properties: C:\oracle11g\hoitdevweb3\product\11.2.0\dbhome_1
[main] [ 2012-03-28 10:23:38.047 AST ] [HAUtils.getCRSHome:588] Getting configured CRS/HAS …
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 11 February 2012 02:04 «»
By: aallan
Re: Create HTML table problem in email
…Michel for reply,
this is my code:
Create Or Replace Procedure Sale.Html_Email_With_Attach(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 08 February 2012 01:03 «»
By: aallan
Re: Attache external file using UTL_SMTP package
…Amit;
I user this procedure but i have a problem with the attached file, it as arrive in the sent email but attached file has a wrong data!!
if you can solve it i will appreciate that.
Create Or Replace Procedure Sale.Html_Email_With_Attach(
…
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 February 2012 07:42 «»
By: aallan
Re: Create HTML table problem in email
…you...
i searched and found this code:
Create Or Replace Procedure Sale.Html_Email_With_Attach(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 February 2012 02:03 «»
By: aallan
Create HTML table problem in email
…Dears;
I used this procedure to send html email:
Create Or Replace Procedure Sale.Html_Email(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 30 |
Forum: Server Administration «»
Posted on: Wed, 01 February 2012 00:32 «»
By: x-oracle
Re: ora 01092 oracle instance terminated
…i am sending you a complite steps of how can we create a manul database you just read it and just change the path and name of the database as you want
first
1. Decide the name of New database
2. ORACLE_SID=ORA10G... (set into Env variable )
3…
|
| 31 |
Forum: Networking and Gateways «»
Posted on: Wed, 25 January 2012 21:31 «»
By: reym21
dblinks
…day!
Please help me to connect Oracle 10g (connecting dB) to Oracle 7.3.4 (remote dB) via dblink (both in DEV environment). I encounter these errors everytime I attempted to, re:
ORA-12545: Connect failed because target host or object does not exist…
|
| 32 |
Forum: Server Administration «»
Posted on: Mon, 19 December 2011 23:20 «»
By: Bilal Khan
DATABASE CREATION
…all.
i wana create database in oracle 10g, but it display error mesage.
i follow following steps
C:\SET ORACLE_SID = ALI
THEN CREATE PASSWORD FILE,AND STARTUP THE PFILE, THEN RUN FOLLOWING CODE TO CREATE THE DATABASE.
CREATE DATABASE ali
…
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 14 November 2011 12:10 «»
By: tuchubby
Querying through dynamic database links using DBMS_SQL
…is my first post here, please forgive me for anything that I missed. I am using SQL Developer.
I am self-teaching myself PL/SQL. What I am trying accomplish is to run a select query across many database links at runtime and to insert that query onto a …
|
| 34 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 13 October 2011 06:05 «»
By: muktha_22
Re: Problem in DBMS_FILE_TRANSFER.PUT_FILE
…Michel/Jhon,
Still I am not able understand the issue.
SQL> create database link link8 connect to bkpusr identified by Issl#2010 using '10GTEST';
Database link created.
SQL> select * from tab@link8;
TNAME …
|
| 35 |
Forum: Linux «»
Posted on: Sat, 24 September 2011 14:56 «»
By: JiXO
Re: Enterprise Manager error
…is the content of alert_orcl.log
Thu Sep 22 17:17:33 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using …
|
| 36 |
Forum: Performance Tuning «»
Posted on: Fri, 02 September 2011 07:08 «»
By: msol25
Re: how we can match variable sga using v$sga and v$sgastat views
…Michel,
Please find details :
SQL> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size…
|
| 37 |
Forum: Server Utilities «»
Posted on: Tue, 02 August 2011 05:28 «»
By: dkdms2124
Re: Clone Database user
…I run the Batch file, I got below mentioned error:
--------------------------------------------------------------------------------
Create a new schema/user like an existing schema/user.
Defaults are shown between brackets…
|
| 38 |
Forum: Server Administration «»
Posted on: Wed, 04 May 2011 01:13 «»
By: Michel Cadot
Re: database in mount mode
…that work and those that does not work (in 10.2.0.4).
DO NOT WORK:
GV$AQ1
GV$LOGMNR_CONTENTS
GV$LOGMNR_REGION
GV$LOGSTDBY_PROGRESS
GV$LOGSTDBY_STATE
GV$RSRC_PLAN_HISTORY
GV$SEGMENT_STATISTICS
GV$STREAMS_CAPTURE
GV$TEMP_EXTENT_MAP
GV$…
|
| 39 |
Forum: Linux «»
Posted on: Mon, 02 May 2011 13:10 «»
By: juniorpeardba
Re: SQL Plus no access
…Hi,
log file from installation
more installActions2011-04-28_02-48-23PM.log
Using paramFile: /opt/oracle/Disk1/install/oraparam.ini
Checking Temp space: must be greater than 80 MB. Actual 2693 MB Passed
Checking swap space: must be greater …
|
| 40 |
Forum: Server Administration «»
Posted on: Mon, 02 May 2011 06:47 «»
By: juniorpeardba
Re: incorrect version of oracle
…Hello,
here are the results of the log file
more installActions2011-04-28_02-48-23PM.log
Using paramFile: /opt/oracle/Disk1/install/oraparam.ini
Checking Temp space: must be greater than 80 MB. Actual 2693 MB Passed
Checking swap space…
|
Blog
Search
Help
Members
Register
Login
Home